import pandas as pd

if __name__ == '__main__':
    file_name_path = "C:\\Users\\xyh\\Desktop\\工作簿1.xlsx"
    data = pd.read_excel(file_name_path, sheet_name='Sheet1', usecols=['工号', '名字', '时间'])
    for index, row in data.iterrows():
        save_sql = """
        INSERT INTO  kc_user_clockin (`user_no`, `user_name`, `seat`, `lat`, `lon`, `clockin_time`, `image_id`, `msg`, `type`) VALUES ('{0}', '{1}', '中国四川省成都市青羊区黄田坝街道土龙路', 30.7226090, 103.9566350, '{2}', '', NULL, '1');        
        """.format(row['工号'], row['名字'], row['时间'])
        print(save_sql)



